MERGE JOIN CARTESIAN
Short Description
Cartesian product. All rows are joined to all rows.
Where to use​
A Merge Join Cartesian can occur where no join conditions are specified. Every row in the first set is joined with every row in the second set and the result passed on to the next explain step.
Further Reading​
- Oracle Magazine - How to read an execution plan
- Oracle Tuning Guide - Explaining and Displaying Execution Plans
- Oracle Tuning Guide - Comparing Execution Plans Tutorial
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.